/*
The purpose of the script is to create the first Administrator User in the
APM system.

Edit the following to specify the correct data.
Set @alias = '' -- Specify the user Alias.
Set @userName = '' -- Specify the user Name.


*/
USE [APM]
GO
Declare @alias varchar(50)
Declare @userName varchar(50)
Declare @useremail  varchar(50)
Set @alias = 'vbatta' -- Specify the user Alias.
Set @userName = 'Vineet Batta' -- Specify the user Name.
set @useremail = 'vbatta@microsoft.com'

INSERT INTO SPMUser (UserGuid,UserName,UserEmail,UserAlias,IsAdmin,Active,CreatedBy,CreatedDate)
 values
(newiD(),@userName,@useremail,@alias,1,1,'INSTALLATION',getdate())
